USE [master]
GO

/****** Object:  Database [ChemistryProject]    Script Date: 08/13/2011 18:42:26 ******/
CREATE DATABASE [ChemistryProject] ON  PRIMARY 
( NAME = N'ChemistryProject', FILENAME = N'c:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\DATA\ChemistryProject.mdf' , SIZE = 2048KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
 LOG ON 
( NAME = N'ChemistryProject_log', FILENAME = N'c:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\DATA\ChemistryProject_log.ldf' , SIZE = 1024KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
GO

USE ChemistryProject
GO

-----------------------------------------------------------------------------------------------
------------------------ CREATE TABLES									 -----------------------
-----------------------------------------------------------------------------------------------
CREATE TABLE Users
(
Username varchar(20) primary key,
Password varchar(20)
)




-----------------------------------------------------------------------------------------------
------------------------ INSERT VALUES    								 -----------------------
-----------------------------------------------------------------------------------------------
INSERT INTO Users VALUES('admin','admin')
select * from users